﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Uri uri = new Uri("http://localhost:31826/WcfDataService.svc");
        var entities=new ServiceReference.Entities(uri);
        var departments = from c in entities.EMP_DETAILS_VIEW
                          where c.FIRST_NAME.Contains("aaa")
                          select c;
        var result = departments.ToList();
        var x = 1;
    }
}